Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$RECOVERY_STATUS

`V$RECOVERY_STATUS` contains statistics of the current recovery process. This view contains useful information only for the Oracle process doing the recovery. When Recovery Manager directs a server process to perform recovery, only Recovery Manager is able to view the relevant information in this view. `V$RECOVERY_STATUS` will be empty to all other Oracle users.

Column | Datatype | Description
--- | --- | ---
`RECOVERY_CHECKPOINT` | `DATE` | Point in time to which the recovery has occurred. If no logs have been applied, this is the point in time the recovery starts.
`THREAD` | `NUMBER` | Number of the redo thread currently being processed
`SEQUENCE_NEEDED` | `NUMBER` | Log sequence number of the log needed by the recovery process. The value is `0` if no log is needed.
`SCN_NEEDED` | `VARCHAR2(16)` | Low SCN of the log needed by recovery. The value is `0` if unknown or no log is needed.
`TIME_NEEDED` | `DATE` | Time when the log was created. The value is midnight on 1/1/88 if the time is unknown or if no log is needed.
`PREVIOUS_LOG_NAME` | `VARCHAR2(513)` | Filename of the log
`PREVIOUS_LOG_STATUS` | `VARCHAR2(13)` | Status of the previous log. Contains one of the following values: `RELEASE; WRONG NAME; MISSING NAME; UNNEEDED NAME; NONE`
`REASON` | `VARCHAR2(13)` | Reason recovery is returning control to the user (`NEED LOG|LOG REUSED|THREAD DISABLED`)

See Also: Oracle Database Backup and Recovery Basics